Overview

Brought to you by YData

Dataset statistics

Number of variables	32
Number of observations	100000
Missing cells	124283
Missing cells (%)	3.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	24.4 MiB
Average record size in memory	256.0 B

Variable types

DateTime	1
Categorical	6
Numeric	21
Text	4

Alerts

`AIRLINE` is highly overall correlated with `AIRLINE_CODE` and 2 other fields	High correlation
`AIRLINE_CODE` is highly overall correlated with `AIRLINE` and 2 other fields	High correlation
`AIRLINE_DOT` is highly overall correlated with `AIRLINE` and 2 other fields	High correlation
`AIR_TIME` is highly overall correlated with `CANCELLED` and 4 other fields	High correlation
`ARR_DELAY` is highly overall correlated with `CANCELLED` and 2 other fields	High correlation
`ARR_TIME` is highly overall correlated with `CANCELLED` and 5 other fields	High correlation
`CANCELLATION_CODE` is highly overall correlated with `CANCELLED` and 6 other fields	High correlation
`CANCELLED` is highly overall correlated with `AIR_TIME` and 6 other fields	High correlation
`CRS_ARR_TIME` is highly overall correlated with `ARR_TIME` and 4 other fields	High correlation
`CRS_DEP_TIME` is highly overall correlated with `ARR_TIME` and 4 other fields	High correlation
`CRS_ELAPSED_TIME` is highly overall correlated with `AIR_TIME` and 2 other fields	High correlation
`DELAY_DUE_CARRIER` is highly overall correlated with `CANCELLATION_CODE`	High correlation
`DELAY_DUE_LATE_AIRCRAFT` is highly overall correlated with `CANCELLATION_CODE`	High correlation
`DELAY_DUE_NAS` is highly overall correlated with `CANCELLATION_CODE`	High correlation
`DELAY_DUE_SECURITY` is highly overall correlated with `CANCELLATION_CODE`	High correlation
`DELAY_DUE_WEATHER` is highly overall correlated with `CANCELLATION_CODE`	High correlation
`DEP_DELAY` is highly overall correlated with `ARR_DELAY`	High correlation
`DEP_TIME` is highly overall correlated with `ARR_TIME` and 4 other fields	High correlation
`DISTANCE` is highly overall correlated with `AIR_TIME` and 2 other fields	High correlation
`DIVERTED` is highly overall correlated with `AIR_TIME` and 3 other fields	High correlation
`DOT_CODE` is highly overall correlated with `AIRLINE` and 2 other fields	High correlation
`ELAPSED_TIME` is highly overall correlated with `AIR_TIME` and 4 other fields	High correlation
`TAXI_IN` is highly overall correlated with `CANCELLED`	High correlation
`WHEELS_OFF` is highly overall correlated with `ARR_TIME` and 4 other fields	High correlation
`WHEELS_ON` is highly overall correlated with `ARR_TIME` and 5 other fields	High correlation
`CANCELLED` is highly imbalanced (82.5%)	Imbalance
`DIVERTED` is highly imbalanced (97.7%)	Imbalance
`DEP_TIME` has 2576 (2.6%) missing values	Missing
`DEP_DELAY` has 2577 (2.6%) missing values	Missing
`TAXI_OUT` has 2618 (2.6%) missing values	Missing
`WHEELS_OFF` has 2618 (2.6%) missing values	Missing
`WHEELS_ON` has 2655 (2.7%) missing values	Missing
`TAXI_IN` has 2655 (2.7%) missing values	Missing
`ARR_TIME` has 2655 (2.7%) missing values	Missing
`ARR_DELAY` has 2852 (2.9%) missing values	Missing
`CANCELLATION_CODE` has 97373 (97.4%) missing values	Missing
`ELAPSED_TIME` has 2852 (2.9%) missing values	Missing
`AIR_TIME` has 2852 (2.9%) missing values	Missing
`DELAY_DUE_WEATHER` is highly skewed (γ1 = 44.38001929)	Skewed
`DELAY_DUE_NAS` is highly skewed (γ1 = 24.49245129)	Skewed
`DELAY_DUE_SECURITY` is highly skewed (γ1 = 119.2410852)	Skewed
`DEP_DELAY` has 4851 (4.9%) zeros	Zeros
`ARR_DELAY` has 1853 (1.9%) zeros	Zeros
`DELAY_DUE_CARRIER` has 90096 (90.1%) zeros	Zeros
`DELAY_DUE_WEATHER` has 98965 (99.0%) zeros	Zeros
`DELAY_DUE_NAS` has 91256 (91.3%) zeros	Zeros
`DELAY_DUE_SECURITY` has 99898 (99.9%) zeros	Zeros
`DELAY_DUE_LATE_AIRCRAFT` has 91377 (91.4%) zeros	Zeros

Reproduction

Analysis started	2025-07-07 15:08:23.003777
Analysis finished	2025-07-07 15:09:44.031429
Duration	1 minute and 21.03 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

FL_DATE
Date

Distinct	1704
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

Minimum	2019-01-01 00:00:00
Maximum	2023-08-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

AIRLINE
Categorical

High correlation

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

Southwest Airlines Co.	19150
Delta Air Lines Inc.	13070
American Airlines Inc.	12874
SkyWest Airlines Inc.	11306
United Air Lines Inc.	8506
Other values (13)	35094

Length

Max length	34
Median length	22
Mean length	19.59848
Min length	9

Characters and Unicode

Total characters	1959848
Distinct characters	43
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Allegiant Air
2nd row	American Airlines Inc.
3rd row	PSA Airlines Inc.
4th row	Southwest Airlines Co.
5th row	Southwest Airlines Co.

Common Values

Value	Count	Frequency (%)
Southwest Airlines Co.	19150	19.1%
Delta Air Lines Inc.	13070	13.1%
American Airlines Inc.	12874	12.9%
SkyWest Airlines Inc.	11306	11.3%
United Air Lines Inc.	8506	8.5%
Republic Airline	4955	5.0%
Envoy Air	3958	4.0%
Endeavor Air Inc.	3748	3.7%
JetBlue Airways	3729	3.7%
PSA Airlines Inc.	3662	3.7%
Other values (8)	15042	15.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
inc	61939	20.1%
airlines	56414	18.3%
air	34902	11.3%
lines	24787	8.1%
southwest	19150	6.2%
co	19150	6.2%
delta	13070	4.2%
american	12874	4.2%
skywest	11306	3.7%
united	8506	2.8%
Other values (18)	45725	14.9%

Most occurring characters

Value	Count	Frequency (%)
i	225519	11.5%
	207823	10.6%
n	182787	9.3%
e	174571	8.9%
r	125542	6.4%
s	122260	6.2%
A	121745	6.2%
l	90075	4.6%
t	82711	4.2%
.	81089	4.1%
Other values (33)	545726	27.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1959848	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	225519	11.5%
	207823	10.6%
n	182787	9.3%
e	174571	8.9%
r	125542	6.4%
s	122260	6.2%
A	121745	6.2%
l	90075	4.6%
t	82711	4.2%
.	81089	4.1%
Other values (33)	545726	27.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1959848	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	225519	11.5%
	207823	10.6%
n	182787	9.3%
e	174571	8.9%
r	125542	6.4%
s	122260	6.2%
A	121745	6.2%
l	90075	4.6%
t	82711	4.2%
.	81089	4.1%
Other values (33)	545726	27.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1959848	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	225519	11.5%
	207823	10.6%
n	182787	9.3%
e	174571	8.9%
r	125542	6.4%
s	122260	6.2%
A	121745	6.2%
l	90075	4.6%
t	82711	4.2%
.	81089	4.1%
Other values (33)	545726	27.8%

AIRLINE_DOT
Categorical

High correlation

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

Southwest Airlines Co.: WN	19150
Delta Air Lines Inc.: DL	13070
American Airlines Inc.: AA	12874
SkyWest Airlines Inc.: OO	11306
United Air Lines Inc.: UA	8506
Other values (13)	35094

Length

Max length	38
Median length	26
Mean length	23.59848
Min length	13

Characters and Unicode

Total characters	2359848
Distinct characters	55
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Allegiant Air: G4
2nd row	American Airlines Inc.: AA
3rd row	PSA Airlines Inc.: OH
4th row	Southwest Airlines Co.: WN
5th row	Southwest Airlines Co.: WN

Common Values

Value	Count	Frequency (%)
Southwest Airlines Co.: WN	19150	19.1%
Delta Air Lines Inc.: DL	13070	13.1%
American Airlines Inc.: AA	12874	12.9%
SkyWest Airlines Inc.: OO	11306	11.3%
United Air Lines Inc.: UA	8506	8.5%
Republic Airline: YX	4955	5.0%
Envoy Air: MQ	3958	4.0%
Endeavor Air Inc.: 9E	3748	3.7%
JetBlue Airways: B6	3729	3.7%
PSA Airlines Inc.: OH	3662	3.7%
Other values (8)	15042	15.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
inc	61939	15.2%
airlines	56414	13.8%
air	34902	8.6%
lines	24787	6.1%
southwest	19150	4.7%
co	19150	4.7%
wn	19150	4.7%
delta	13070	3.2%
dl	13070	3.2%
american	12874	3.2%
Other values (36)	133317	32.7%

Most occurring characters

Value	Count	Frequency (%)
	307823	13.0%
i	225519	9.6%
n	182787	7.7%
e	174571	7.4%
A	160465	6.8%
r	125542	5.3%
s	122260	5.2%
:	100000	4.2%
l	90075	3.8%
t	82711	3.5%
Other values (45)	788095	33.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2359848	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	307823	13.0%
i	225519	9.6%
n	182787	7.7%
e	174571	7.4%
A	160465	6.8%
r	125542	5.3%
s	122260	5.2%
:	100000	4.2%
l	90075	3.8%
t	82711	3.5%
Other values (45)	788095	33.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2359848	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	307823	13.0%
i	225519	9.6%
n	182787	7.7%
e	174571	7.4%
A	160465	6.8%
r	125542	5.3%
s	122260	5.2%
:	100000	4.2%
l	90075	3.8%
t	82711	3.5%
Other values (45)	788095	33.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2359848	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	307823	13.0%
i	225519	9.6%
n	182787	7.7%
e	174571	7.4%
A	160465	6.8%
r	125542	5.3%
s	122260	5.2%
:	100000	4.2%
l	90075	3.8%
t	82711	3.5%
Other values (45)	788095	33.4%

AIRLINE_CODE
Categorical

High correlation

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

WN	19150
DL	13070
AA	12874
OO	11306
UA	8506
Other values (13)	35094

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	200000
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	G4
2nd row	AA
3rd row	OH
4th row	WN
5th row	WN

Common Values

Value	Count	Frequency (%)
WN	19150	19.1%
DL	13070	13.1%
AA	12874	12.9%
OO	11306	11.3%
UA	8506	8.5%
YX	4955	5.0%
MQ	3958	4.0%
9E	3748	3.7%
B6	3729	3.7%
OH	3662	3.7%
Other values (8)	15042	15.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
wn	19150	19.1%
dl	13070	13.1%
aa	12874	12.9%
oo	11306	11.3%
ua	8506	8.5%
yx	4955	5.0%
mq	3958	4.0%
9e	3748	3.7%
b6	3729	3.7%
oh	3662	3.7%
Other values (8)	15042	15.0%

Most occurring characters

Value	Count	Frequency (%)
A	38720	19.4%
O	26274	13.1%
N	22361	11.2%
W	19150	9.6%
D	13070	6.5%
L	13070	6.5%
U	8506	4.3%
Y	7065	3.5%
9	5945	3.0%
X	5621	2.8%
Other values (12)	40218	20.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	200000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	38720	19.4%
O	26274	13.1%
N	22361	11.2%
W	19150	9.6%
D	13070	6.5%
L	13070	6.5%
U	8506	4.3%
Y	7065	3.5%
9	5945	3.0%
X	5621	2.8%
Other values (12)	40218	20.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	200000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	38720	19.4%
O	26274	13.1%
N	22361	11.2%
W	19150	9.6%
D	13070	6.5%
L	13070	6.5%
U	8506	4.3%
Y	7065	3.5%
9	5945	3.0%
X	5621	2.8%
Other values (12)	40218	20.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	200000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	38720	19.4%
O	26274	13.1%
N	22361	11.2%
W	19150	9.6%
D	13070	6.5%
L	13070	6.5%
U	8506	4.3%
Y	7065	3.5%
9	5945	3.0%
X	5621	2.8%
Other values (12)	40218	20.1%

DOT_CODE
Real number (ℝ)

High correlation

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19977.258

Minimum	19393
Maximum	20452
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	19393
5-th percentile	19393
Q1	19790
median	19930
Q3	20368
95-th percentile	20436
Maximum	20452
Range	1059
Interquartile range (IQR)	578

Descriptive statistics

Standard deviation	377.22316
Coefficient of variation (CV)	0.01888263
Kurtosis	-1.30732
Mean	19977.258
Median Absolute Deviation (MAD)	374
Skewness	-0.23188721
Sum	1.9977258 × 10⁹
Variance	142297.31
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
19393	19150	19.1%
19790	13070	13.1%
19805	12874	12.9%
20304	11306	11.3%
19977	8506	8.5%
20452	4955	5.0%
20398	3958	4.0%
20363	3748	3.7%
20409	3729	3.7%
20397	3662	3.7%
Other values (8)	15042	15.0%

Value	Count	Frequency (%)
19393	19150	19.1%
19687	666	0.7%
19690	1000	1.0%
19790	13070	13.1%
19805	12874	12.9%
19930	3466	3.5%
19977	8506	8.5%
20304	11306	11.3%
20363	3748	3.7%
20366	649	0.6%

Value	Count	Frequency (%)
20452	4955	5.0%
20436	2197	2.2%
20416	3211	3.2%
20409	3729	3.7%
20398	3958	4.0%
20397	3662	3.7%
20378	2110	2.1%
20368	1743	1.7%
20366	649	0.6%
20363	3748	3.7%

FL_NUMBER
Real number (ℝ)

Distinct	6541
Distinct (%)	6.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2511.9107

Minimum	1
Maximum	8819
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	1
5-th percentile	262
Q1	1054
median	2150
Q3	3794
95-th percentile	5651
Maximum	8819
Range	8818
Interquartile range (IQR)	2740

Descriptive statistics

Standard deviation	1745.6329
Coefficient of variation (CV)	0.69494228
Kurtosis	-0.89656803
Mean	2511.9107
Median Absolute Deviation (MAD)	1333
Skewness	0.50518122
Sum	2.5119107 × 10⁸
Variance	3047234.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
676	54	0.1%
320	53	0.1%
334	52	0.1%
350	48	< 0.1%
61	48	< 0.1%
710	47	< 0.1%
55	47	< 0.1%
517	46	< 0.1%
678	46	< 0.1%
777	45	< 0.1%
Other values (6531)	99514	99.5%

Value	Count	Frequency (%)
1	30	< 0.1%
2	24	< 0.1%
3	30	< 0.1%
4	21	< 0.1%
5	28	< 0.1%
6	32	< 0.1%
7	21	< 0.1%
8	26	< 0.1%
9	14	< 0.1%
10	27	< 0.1%

Value	Count	Frequency (%)
8819	1	< 0.1%
8795	1	< 0.1%
8783	1	< 0.1%
8771	1	< 0.1%
7439	1	< 0.1%
7438	2	< 0.1%
7436	1	< 0.1%
7434	2	< 0.1%
7429	2	< 0.1%
7426	1	< 0.1%

ORIGIN
Text

Distinct	372
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	300000
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	PGD
2nd row	DFW
3rd row	EWN
4th row	ABQ
5th row	PIT

Value	Count	Frequency (%)
atl	5099	5.1%
dfw	4444	4.4%
ord	4053	4.1%
den	3886	3.9%
clt	3110	3.1%
lax	2866	2.9%
phx	2460	2.5%
sea	2451	2.5%
las	2391	2.4%
iah	2180	2.2%
Other values (362)	67060	67.1%

Most occurring characters

Value	Count	Frequency (%)
A	33825	11.3%
L	27711	9.2%
S	25102	8.4%
D	23886	8.0%
T	16671	5.6%
C	15373	5.1%
O	15190	5.1%
M	13305	4.4%
F	12605	4.2%
W	12152	4.1%
Other values (16)	104180	34.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	300000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	33825	11.3%
L	27711	9.2%
S	25102	8.4%
D	23886	8.0%
T	16671	5.6%
C	15373	5.1%
O	15190	5.1%
M	13305	4.4%
F	12605	4.2%
W	12152	4.1%
Other values (16)	104180	34.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	300000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	33825	11.3%
L	27711	9.2%
S	25102	8.4%
D	23886	8.0%
T	16671	5.6%
C	15373	5.1%
O	15190	5.1%
M	13305	4.4%
F	12605	4.2%
W	12152	4.1%
Other values (16)	104180	34.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	300000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	33825	11.3%
L	27711	9.2%
S	25102	8.4%
D	23886	8.0%
T	16671	5.6%
C	15373	5.1%
O	15190	5.1%
M	13305	4.4%
F	12605	4.2%
W	12152	4.1%
Other values (16)	104180	34.7%

ORIGIN_CITY
Text

Distinct	366
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

Length

Max length	34
Median length	29
Mean length	13.12925
Min length	8

Characters and Unicode

Total characters	1312925
Distinct characters	58
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	Punta Gorda, FL
2nd row	Dallas/Fort Worth, TX
3rd row	New Bern/Morehead/Beaufort, NC
4th row	Albuquerque, NM
5th row	Pittsburgh, PA

Value	Count	Frequency (%)
tx	11010	4.7%
ca	10574	4.5%
fl	8561	3.7%
ga	5469	2.3%
il	5462	2.3%
chicago	5219	2.2%
atlanta	5099	2.2%
san	5043	2.2%
ny	4994	2.1%
new	4616	2.0%
Other values (442)	166755	71.6%

Most occurring characters

Value	Count	Frequency (%)
	132802	10.1%
a	100128	7.6%
,	100000	7.6%
o	73394	5.6%
e	69031	5.3%
t	65240	5.0%
n	64075	4.9%
l	58680	4.5%
i	50423	3.8%
r	47833	3.6%
Other values (48)	551319	42.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1312925	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	132802	10.1%
a	100128	7.6%
,	100000	7.6%
o	73394	5.6%
e	69031	5.3%
t	65240	5.0%
n	64075	4.9%
l	58680	4.5%
i	50423	3.8%
r	47833	3.6%
Other values (48)	551319	42.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1312925	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	132802	10.1%
a	100128	7.6%
,	100000	7.6%
o	73394	5.6%
e	69031	5.3%
t	65240	5.0%
n	64075	4.9%
l	58680	4.5%
i	50423	3.8%
r	47833	3.6%
Other values (48)	551319	42.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1312925	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	132802	10.1%
a	100128	7.6%
,	100000	7.6%
o	73394	5.6%
e	69031	5.3%
t	65240	5.0%
n	64075	4.9%
l	58680	4.5%
i	50423	3.8%
r	47833	3.6%
Other values (48)	551319	42.0%

DEST
Text

Distinct	376
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	300000
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	SPI
2nd row	LAX
3rd row	CLT
4th row	DEN
5th row	STL

Value	Count	Frequency (%)
atl	5095	5.1%
dfw	4239	4.2%
ord	4157	4.2%
den	3956	4.0%
clt	3269	3.3%
lax	2804	2.8%
phx	2628	2.6%
las	2413	2.4%
sea	2323	2.3%
mco	2171	2.2%
Other values (366)	66945	66.9%

Most occurring characters

Value	Count	Frequency (%)
A	33522	11.2%
L	27841	9.3%
S	25056	8.4%
D	23828	7.9%
T	16592	5.5%
C	15450	5.1%
O	15428	5.1%
M	13505	4.5%
F	12402	4.1%
P	11838	3.9%
Other values (16)	104538	34.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	300000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	33522	11.2%
L	27841	9.3%
S	25056	8.4%
D	23828	7.9%
T	16592	5.5%
C	15450	5.1%
O	15428	5.1%
M	13505	4.5%
F	12402	4.1%
P	11838	3.9%
Other values (16)	104538	34.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	300000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	33522	11.2%
L	27841	9.3%
S	25056	8.4%
D	23828	7.9%
T	16592	5.5%
C	15450	5.1%
O	15428	5.1%
M	13505	4.5%
F	12402	4.1%
P	11838	3.9%
Other values (16)	104538	34.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	300000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	33522	11.2%
L	27841	9.3%
S	25056	8.4%
D	23828	7.9%
T	16592	5.5%
C	15450	5.1%
O	15428	5.1%
M	13505	4.5%
F	12402	4.1%
P	11838	3.9%
Other values (16)	104538	34.8%

DEST_CITY
Text

Distinct	369
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

Length

Max length	34
Median length	29
Mean length	13.09602
Min length	8

Characters and Unicode

Total characters	1309602
Distinct characters	58
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	Springfield, IL
2nd row	Los Angeles, CA
3rd row	Charlotte, NC
4th row	Denver, CO
5th row	St. Louis, MO

Value	Count	Frequency (%)
tx	10708	4.6%
ca	10524	4.5%
fl	8764	3.8%
il	5587	2.4%
ga	5466	2.4%
chicago	5359	2.3%
atlanta	5095	2.2%
san	5036	2.2%
ny	4825	2.1%
nc	4634	2.0%
Other values (445)	166412	71.6%

Most occurring characters

Value	Count	Frequency (%)
	132410	10.1%
a	100289	7.7%
,	100000	7.6%
o	73036	5.6%
e	68819	5.3%
t	64523	4.9%
n	63980	4.9%
l	58137	4.4%
i	50206	3.8%
r	47275	3.6%
Other values (48)	550927	42.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1309602	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	132410	10.1%
a	100289	7.7%
,	100000	7.6%
o	73036	5.6%
e	68819	5.3%
t	64523	4.9%
n	63980	4.9%
l	58137	4.4%
i	50206	3.8%
r	47275	3.6%
Other values (48)	550927	42.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1309602	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	132410	10.1%
a	100289	7.7%
,	100000	7.6%
o	73036	5.6%
e	68819	5.3%
t	64523	4.9%
n	63980	4.9%
l	58137	4.4%
i	50206	3.8%
r	47275	3.6%
Other values (48)	550927	42.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1309602	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	132410	10.1%
a	100289	7.7%
,	100000	7.6%
o	73036	5.6%
e	68819	5.3%
t	64523	4.9%
n	63980	4.9%
l	58137	4.4%
i	50206	3.8%
r	47275	3.6%
Other values (48)	550927	42.1%

CRS_DEP_TIME
Real number (ℝ)

High correlation

Distinct	1238
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1329.3123

Minimum	4
Maximum	2359
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	4
5-th percentile	605
Q1	915
median	1322
Q3	1730
95-th percentile	2120
Maximum	2359
Range	2355
Interquartile range (IQR)	815

Descriptive statistics

Standard deviation	485.41853
Coefficient of variation (CV)	0.36516515
Kurtosis	-1.0347969
Mean	1329.3123
Median Absolute Deviation (MAD)	407
Skewness	0.085529116
Sum	1.3293123 × 10⁸
Variance	235631.15
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
600	2073	2.1%
700	1687	1.7%
800	1034	1.0%
830	700	0.7%
900	685	0.7%
630	663	0.7%
1000	646	0.6%
730	645	0.6%
1100	568	0.6%
715	529	0.5%
Other values (1228)	90770	90.8%

Value	Count	Frequency (%)
4	1	< 0.1%
5	2	< 0.1%
6	1	< 0.1%
7	2	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	2	< 0.1%
14	3	< 0.1%
15	9	< 0.1%
16	1	< 0.1%

Value	Count	Frequency (%)
2359	118	0.1%
2358	10	< 0.1%
2357	3	< 0.1%
2356	8	< 0.1%
2355	54	0.1%
2354	1	< 0.1%
2353	2	< 0.1%
2352	3	< 0.1%
2351	3	< 0.1%
2350	29	< 0.1%

DEP_TIME
Real number (ℝ)

High correlation Missing

Distinct	1332
Distinct (%)	1.4%
Missing	2576
Missing (%)	2.6%
Infinite	0
Infinite (%)	0.0%
Mean	1331.0057

Minimum	1
Maximum	2400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	1
5-th percentile	603
Q1	918
median	1325
Q3	1738
95-th percentile	2133
Maximum	2400
Range	2399
Interquartile range (IQR)	820

Descriptive statistics

Standard deviation	498.86463
Coefficient of variation (CV)	0.37480276
Kurtosis	-0.96405827
Mean	1331.0057
Median Absolute Deviation (MAD)	411
Skewness	0.040328846
Sum	1.296719 × 10⁸
Variance	248865.91
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
555	279	0.3%
556	253	0.3%
655	227	0.2%
557	222	0.2%
558	220	0.2%
554	214	0.2%
559	214	0.2%
600	202	0.2%
656	198	0.2%
700	188	0.2%
Other values (1322)	95207	95.2%
(Missing)	2576	2.6%

Value	Count	Frequency (%)
1	13	< 0.1%
2	8	< 0.1%
3	9	< 0.1%
4	14	< 0.1%
5	8	< 0.1%
6	11	< 0.1%
7	9	< 0.1%
8	11	< 0.1%
9	6	< 0.1%
10	10	< 0.1%

Value	Count	Frequency (%)
2400	8	< 0.1%
2359	9	< 0.1%
2358	16	< 0.1%
2357	20	< 0.1%
2356	14	< 0.1%
2355	18	< 0.1%
2354	9	< 0.1%
2353	19	< 0.1%
2352	14	< 0.1%
2351	20	< 0.1%

DEP_DELAY
Real number (ℝ)

High correlation Missing Zeros

Distinct	590
Distinct (%)	0.6%
Missing	2577
Missing (%)	2.6%
Infinite	0
Infinite (%)	0.0%
Mean	10.178007

Minimum	-81
Maximum	1512
Zeros	4851
Zeros (%)	4.9%
Negative	59451
Negative (%)	59.5%
Memory size	781.4 KiB

Quantile statistics

Minimum	-81
5-th percentile	-10
Q1	-6
median	-2
Q3	6
95-th percentile	72
Maximum	1512
Range	1593
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	49.398318
Coefficient of variation (CV)	4.8534371
Kurtosis	189.01187
Mean	10.178007
Median Absolute Deviation (MAD)	4
Skewness	10.773897
Sum	991572
Variance	2440.1939
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-5	8093	8.1%
-4	7517	7.5%
-3	7078	7.1%
-6	6340	6.3%
-2	6272	6.3%
-1	5498	5.5%
-7	5044	5.0%
0	4851	4.9%
-8	3979	4.0%
-9	2885	2.9%
Other values (580)	39866	39.9%

Value	Count	Frequency (%)
-81	1	< 0.1%
-42	2	< 0.1%
-38	1	< 0.1%
-36	1	< 0.1%
-35	2	< 0.1%
-34	2	< 0.1%
-32	1	< 0.1%
-29	5	< 0.1%
-28	1	< 0.1%
-27	8	< 0.1%

Value	Count	Frequency (%)
1512	1	< 0.1%
1469	1	< 0.1%
1441	1	< 0.1%
1376	1	< 0.1%
1286	1	< 0.1%
1256	1	< 0.1%
1255	1	< 0.1%
1214	1	< 0.1%
1211	1	< 0.1%
1205	1	< 0.1%

TAXI_OUT
Real number (ℝ)

Missing

Distinct	135
Distinct (%)	0.1%
Missing	2618
Missing (%)	2.6%
Infinite	0
Infinite (%)	0.0%
Mean	16.679992

Minimum	1
Maximum	163
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	11
median	14
Q3	19
95-th percentile	33
Maximum	163
Range	162
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	9.1706548
Coefficient of variation (CV)	0.5497997
Kurtosis	23.061235
Mean	16.679992
Median Absolute Deviation (MAD)	4
Skewness	3.4144476
Sum	1624331
Variance	84.100909
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12	8093	8.1%
13	7826	7.8%
11	7818	7.8%
14	7157	7.2%
10	7068	7.1%
15	6461	6.5%
16	5450	5.5%
9	5378	5.4%
17	4753	4.8%
18	4013	4.0%
Other values (125)	33365	33.4%

Value	Count	Frequency (%)
1	4	< 0.1%
2	3	< 0.1%
3	20	< 0.1%
4	83	0.1%
5	238	0.2%
6	780	0.8%
7	1803	1.8%
8	3500	3.5%
9	5378	5.4%
10	7068	7.1%

Value	Count	Frequency (%)
163	1	< 0.1%
162	1	< 0.1%
158	1	< 0.1%
157	2	< 0.1%
151	1	< 0.1%
150	1	< 0.1%
147	1	< 0.1%
143	2	< 0.1%
142	2	< 0.1%
139	1	< 0.1%

WHEELS_OFF
Real number (ℝ)

High correlation Missing

Distinct	1338
Distinct (%)	1.4%
Missing	2618
Missing (%)	2.6%
Infinite	0
Infinite (%)	0.0%
Mean	1353.6437

Minimum	1
Maximum	2400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	1
5-th percentile	618
Q1	932
median	1338
Q3	1752
95-th percentile	2146
Maximum	2400
Range	2399
Interquartile range (IQR)	820

Descriptive statistics

Standard deviation	500.4562
Coefficient of variation (CV)	0.36971044
Kurtosis	-0.90000081
Mean	1353.6437
Median Absolute Deviation (MAD)	410
Skewness	0.0066238008
Sum	1.3182053 × 10⁸
Variance	250456.41
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
611	189	0.2%
610	164	0.2%
608	163	0.2%
615	160	0.2%
712	149	0.1%
711	148	0.1%
715	148	0.1%
619	147	0.1%
613	146	0.1%
607	146	0.1%
Other values (1328)	95822	95.8%
(Missing)	2618	2.6%

Value	Count	Frequency (%)
1	22	< 0.1%
2	19	< 0.1%
3	14	< 0.1%
4	12	< 0.1%
5	20	< 0.1%
6	11	< 0.1%
7	14	< 0.1%
8	18	< 0.1%
9	14	< 0.1%
10	23	< 0.1%

Value	Count	Frequency (%)
2400	9	< 0.1%
2359	23	< 0.1%
2358	17	< 0.1%
2357	12	< 0.1%
2356	24	< 0.1%
2355	14	< 0.1%
2354	18	< 0.1%
2353	12	< 0.1%
2352	20	< 0.1%
2351	18	< 0.1%

WHEELS_ON
Real number (ℝ)

High correlation Missing

Distinct	1421
Distinct (%)	1.5%
Missing	2655
Missing (%)	2.7%
Infinite	0
Infinite (%)	0.0%
Mean	1463.905

Minimum	1
Maximum	2400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	1
5-th percentile	654
Q1	1050
median	1502
Q3	1909
95-th percentile	2247
Maximum	2400
Range	2399
Interquartile range (IQR)	859

Descriptive statistics

Standard deviation	527.43063
Coefficient of variation (CV)	0.36029019
Kurtosis	-0.43288968
Mean	1463.905
Median Absolute Deviation (MAD)	416
Skewness	-0.31773495
Sum	1.4250384 × 10⁸
Variance	278183.07
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1820	136	0.1%
930	132	0.1%
1651	131	0.1%
1802	124	0.1%
1836	123	0.1%
1654	123	0.1%
1641	121	0.1%
1715	121	0.1%
1627	120	0.1%
2113	120	0.1%
Other values (1411)	96094	96.1%
(Missing)	2655	2.7%

Value	Count	Frequency (%)
1	48	< 0.1%
2	49	< 0.1%
3	44	< 0.1%
4	47	< 0.1%
5	49	< 0.1%
6	36	< 0.1%
7	45	< 0.1%
8	36	< 0.1%
9	31	< 0.1%
10	40	< 0.1%

Value	Count	Frequency (%)
2400	45	< 0.1%
2359	45	< 0.1%
2358	55	0.1%
2357	62	0.1%
2356	48	< 0.1%
2355	52	0.1%
2354	60	0.1%
2353	63	0.1%
2352	42	< 0.1%
2351	39	< 0.1%

TAXI_IN
Real number (ℝ)

High correlation Missing

Distinct	120
Distinct (%)	0.1%
Missing	2655
Missing (%)	2.7%
Infinite	0
Infinite (%)	0.0%
Mean	7.6952899

Minimum	1
Maximum	261
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	4
median	6
Q3	9
95-th percentile	18
Maximum	261
Range	260
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	6.4810638
Coefficient of variation (CV)	0.84221178
Kurtosis	92.748798
Mean	7.6952899
Median Absolute Deviation (MAD)	2
Skewness	6.088001
Sum	749098
Variance	42.004188
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	15144	15.1%
5	14174	14.2%
6	11318	11.3%
3	10444	10.4%
7	9078	9.1%
8	6843	6.8%
9	5283	5.3%
10	4148	4.1%
11	3304	3.3%
2	3062	3.1%
Other values (110)	14547	14.5%
(Missing)	2655	2.7%

Value	Count	Frequency (%)
1	183	0.2%
2	3062	3.1%
3	10444	10.4%
4	15144	15.1%
5	14174	14.2%
6	11318	11.3%
7	9078	9.1%
8	6843	6.8%
9	5283	5.3%
10	4148	4.1%

Value	Count	Frequency (%)
261	1	< 0.1%
187	1	< 0.1%
184	1	< 0.1%
177	1	< 0.1%
173	1	< 0.1%
160	1	< 0.1%
155	1	< 0.1%
153	1	< 0.1%
151	1	< 0.1%
145	1	< 0.1%

CRS_ARR_TIME
Real number (ℝ)

High correlation

Distinct	1327
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1491.4711

Minimum	1
Maximum	2359
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	1
5-th percentile	725
Q1	1108
median	1519
Q3	1919
95-th percentile	2254
Maximum	2359
Range	2358
Interquartile range (IQR)	811

Descriptive statistics

Standard deviation	512.56987
Coefficient of variation (CV)	0.34366731
Kurtosis	-0.45143412
Mean	1491.4711
Median Absolute Deviation (MAD)	406
Skewness	-0.28739952
Sum	1.4914711 × 10⁸
Variance	262727.88
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2359	324	0.3%
950	297	0.3%
1900	290	0.3%
1000	276	0.3%
2030	267	0.3%
1400	265	0.3%
2000	264	0.3%
2100	262	0.3%
1555	262	0.3%
1835	259	0.3%
Other values (1317)	97234	97.2%

Value	Count	Frequency (%)
1	23	< 0.1%
2	27	< 0.1%
3	30	< 0.1%
4	22	< 0.1%
5	82	0.1%
6	28	< 0.1%
7	16	< 0.1%
8	23	< 0.1%
9	19	< 0.1%
10	89	0.1%

Value	Count	Frequency (%)
2359	324	0.3%
2358	103	0.1%
2357	97	0.1%
2356	78	0.1%
2355	171	0.2%
2354	71	0.1%
2353	68	0.1%
2352	69	0.1%
2351	52	0.1%
2350	142	0.1%

ARR_TIME
Real number (ℝ)

High correlation Missing

Distinct	1410
Distinct (%)	1.4%
Missing	2655
Missing (%)	2.7%
Infinite	0
Infinite (%)	0.0%
Mean	1467.1255

Minimum	1
Maximum	2400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	1
5-th percentile	652
Q1	1053
median	1506
Q3	1913
95-th percentile	2249
Maximum	2400
Range	2399
Interquartile range (IQR)	860

Descriptive statistics

Standard deviation	532.51335
Coefficient of variation (CV)	0.36296373
Kurtosis	-0.35065461
Mean	1467.1255
Median Absolute Deviation (MAD)	413
Skewness	-0.36097268
Sum	1.4281733 × 10⁸
Variance	283570.47
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1115	130	0.1%
1343	129	0.1%
1020	123	0.1%
1655	123	0.1%
1840	122	0.1%
1230	122	0.1%
1052	122	0.1%
1547	121	0.1%
1550	121	0.1%
944	121	0.1%
Other values (1400)	96111	96.1%
(Missing)	2655	2.7%

Value	Count	Frequency (%)
1	67	0.1%
2	50	0.1%
3	61	0.1%
4	42	< 0.1%
5	62	0.1%
6	40	< 0.1%
7	54	0.1%
8	39	< 0.1%
9	48	< 0.1%
10	60	0.1%

Value	Count	Frequency (%)
2400	48	< 0.1%
2359	43	< 0.1%
2358	71	0.1%
2357	59	0.1%
2356	56	0.1%
2355	53	0.1%
2354	59	0.1%
2353	62	0.1%
2352	63	0.1%
2351	68	0.1%

ARR_DELAY
Real number (ℝ)

High correlation Missing Zeros

Distinct	613
Distinct (%)	0.6%
Missing	2852
Missing (%)	2.9%
Infinite	0
Infinite (%)	0.0%
Mean	4.3537592

Minimum	-88
Maximum	1520
Zeros	1853
Zeros (%)	1.9%
Negative	62508
Negative (%)	62.5%
Memory size	781.4 KiB

Quantile statistics

Minimum	-88
5-th percentile	-27
Q1	-15
median	-7
Q3	7
95-th percentile	70
Maximum	1520
Range	1608
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	51.360244
Coefficient of variation (CV)	11.796758
Kurtosis	163.6387
Mean	4.3537592
Median Absolute Deviation (MAD)	10
Skewness	9.7045591
Sum	422959
Variance	2637.8747
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-11	2861	2.9%
-12	2845	2.8%
-13	2834	2.8%
-9	2825	2.8%
-10	2787	2.8%
-7	2753	2.8%
-14	2747	2.7%
-8	2690	2.7%
-15	2631	2.6%
-16	2534	2.5%
Other values (603)	69641	69.6%
(Missing)	2852	2.9%

Value	Count	Frequency (%)
-88	1	< 0.1%
-68	1	< 0.1%
-67	1	< 0.1%
-66	2	< 0.1%
-63	1	< 0.1%
-62	2	< 0.1%
-61	4	< 0.1%
-60	3	< 0.1%
-59	9	< 0.1%
-58	1	< 0.1%

Value	Count	Frequency (%)
1520	1	< 0.1%
1473	1	< 0.1%
1458	1	< 0.1%
1371	1	< 0.1%
1285	1	< 0.1%
1270	1	< 0.1%
1247	1	< 0.1%
1207	1	< 0.1%
1200	1	< 0.1%
1199	1	< 0.1%

CANCELLED
Categorical

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

0.0	97373
1.0	2627

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	300000
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	1.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	97373	97.4%
1.0	2627	2.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	97373	97.4%
1.0	2627	2.6%

Most occurring characters

Value	Count	Frequency (%)
0	197373	65.8%
.	100000	33.3%
1	2627	0.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	300000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	197373	65.8%
.	100000	33.3%
1	2627	0.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	300000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	197373	65.8%
.	100000	33.3%
1	2627	0.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	300000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	197373	65.8%
.	100000	33.3%
1	2627	0.9%

CANCELLATION_CODE
Categorical

High correlation Missing

Distinct	4
Distinct (%)	0.2%
Missing	97373
Missing (%)	97.4%
Memory size	781.4 KiB

B	930
D	827
A	671
C	199

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	2627
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	B
2nd row	B
3rd row	C
4th row	B
5th row	A

Common Values

Value	Count	Frequency (%)
B	930	0.9%
D	827	0.8%
A	671	0.7%
C	199	0.2%
(Missing)	97373	97.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
b	930	35.4%
d	827	31.5%
a	671	25.5%
c	199	7.6%

Most occurring characters

Value	Count	Frequency (%)
B	930	35.4%
D	827	31.5%
A	671	25.5%
C	199	7.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2627	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
B	930	35.4%
D	827	31.5%
A	671	25.5%
C	199	7.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2627	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
B	930	35.4%
D	827	31.5%
A	671	25.5%
C	199	7.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2627	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
B	930	35.4%
D	827	31.5%
A	671	25.5%
C	199	7.6%

DIVERTED
Categorical

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

0.0	99775
1.0	225

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	300000
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	99775	99.8%
1.0	225	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	99775	99.8%
1.0	225	0.2%

Most occurring characters

Value	Count	Frequency (%)
0	199775	66.6%
.	100000	33.3%
1	225	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	300000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	199775	66.6%
.	100000	33.3%
1	225	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	300000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	199775	66.6%
.	100000	33.3%
1	225	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	300000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	199775	66.6%
.	100000	33.3%
1	225	0.1%

CRS_ELAPSED_TIME
Real number (ℝ)

High correlation

Distinct	502
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	142.73547

Minimum	20
Maximum	695
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	20
5-th percentile	64
Q1	90
median	125
Q3	173
95-th percentile	300
Maximum	695
Range	675
Interquartile range (IQR)	83

Descriptive statistics

Standard deviation	71.852142
Coefficient of variation (CV)	0.50339374
Kurtosis	2.5963346
Mean	142.73547
Median Absolute Deviation (MAD)	40
Skewness	1.4467089
Sum	14273547
Variance	5162.7302
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
90	1924	1.9%
85	1812	1.8%
80	1729	1.7%
70	1557	1.6%
75	1500	1.5%
95	1463	1.5%
115	1273	1.3%
105	1258	1.3%
120	1241	1.2%
110	1233	1.2%
Other values (492)	85010	85.0%

Value	Count	Frequency (%)
20	3	< 0.1%
21	2	< 0.1%
23	1	< 0.1%
24	1	< 0.1%
25	3	< 0.1%
26	3	< 0.1%
29	1	< 0.1%
30	2	< 0.1%
32	5	< 0.1%
33	4	< 0.1%

Value	Count	Frequency (%)
695	1	< 0.1%
684	1	< 0.1%
680	1	< 0.1%
675	2	< 0.1%
670	2	< 0.1%
665	1	< 0.1%
660	2	< 0.1%
652	1	< 0.1%
650	2	< 0.1%
646	1	< 0.1%

ELAPSED_TIME
Real number (ℝ)

High correlation Missing

Distinct	514
Distinct (%)	0.5%
Missing	2852
Missing (%)	2.9%
Infinite	0
Infinite (%)	0.0%
Mean	137.07864

Minimum	17
Maximum	706
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	17
5-th percentile	56
Q1	85
median	120
Q3	168
95-th percentile	293
Maximum	706
Range	689
Interquartile range (IQR)	83

Descriptive statistics

Standard deviation	72.041746
Coefficient of variation (CV)	0.52555048
Kurtosis	2.5343943
Mean	137.07864
Median Absolute Deviation (MAD)	40
Skewness	1.4217463
Sum	13316916
Variance	5190.0132
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
87	798	0.8%
79	780	0.8%
85	778	0.8%
83	773	0.8%
76	764	0.8%
82	760	0.8%
81	757	0.8%
75	755	0.8%
72	750	0.8%
77	747	0.7%
Other values (504)	89486	89.5%
(Missing)	2852	2.9%

Value	Count	Frequency (%)
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%
21	1	< 0.1%
22	2	< 0.1%
23	1	< 0.1%
24	2	< 0.1%
25	5	< 0.1%
26	3	< 0.1%
28	9	< 0.1%

Value	Count	Frequency (%)
706	1	< 0.1%
696	1	< 0.1%
687	1	< 0.1%
682	1	< 0.1%
676	1	< 0.1%
668	1	< 0.1%
657	1	< 0.1%
648	1	< 0.1%
644	1	< 0.1%
641	1	< 0.1%

AIR_TIME
Real number (ℝ)

High correlation Missing

Distinct	492
Distinct (%)	0.5%
Missing	2852
Missing (%)	2.9%
Infinite	0
Infinite (%)	0.0%
Mean	112.71605

Minimum	9
Maximum	669
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	9
5-th percentile	35
Q1	62
median	95
Q3	142
95-th percentile	267
Maximum	669
Range	660
Interquartile range (IQR)	80

Descriptive statistics

Standard deviation	70.10449
Coefficient of variation (CV)	0.62195658
Kurtosis	2.6192588
Mean	112.71605
Median Absolute Deviation (MAD)	38
Skewness	1.4556215
Sum	10950139
Variance	4914.6396
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
61	860	0.9%
43	858	0.9%
63	851	0.9%
65	835	0.8%
60	832	0.8%
58	828	0.8%
55	827	0.8%
59	824	0.8%
53	818	0.8%
66	811	0.8%
Other values (482)	88804	88.8%
(Missing)	2852	2.9%

Value	Count	Frequency (%)
9	4	< 0.1%
10	4	< 0.1%
11	2	< 0.1%
12	2	< 0.1%
13	4	< 0.1%
14	3	< 0.1%
15	6	< 0.1%
16	15	< 0.1%
17	29	< 0.1%
18	49	< 0.1%

Value	Count	Frequency (%)
669	1	< 0.1%
659	1	< 0.1%
657	1	< 0.1%
654	2	< 0.1%
634	1	< 0.1%
623	1	< 0.1%
621	1	< 0.1%
614	1	< 0.1%
611	1	< 0.1%
606	1	< 0.1%

DISTANCE
Real number (ℝ)

High correlation

Distinct	1611
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	812.94666

Minimum	29
Maximum	5812
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	29
5-th percentile	175
Q1	386
median	657
Q3	1048
95-th percentile	2153
Maximum	5812
Range	5783
Interquartile range (IQR)	662

Descriptive statistics

Standard deviation	590.42474
Coefficient of variation (CV)	0.72627734
Kurtosis	2.9035067
Mean	812.94666
Median Absolute Deviation (MAD)	320
Skewness	1.5102644
Sum	81294666
Variance	348601.37
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
337	635	0.6%
399	503	0.5%
296	495	0.5%
594	416	0.4%
224	410	0.4%
404	397	0.4%
214	393	0.4%
733	364	0.4%
862	363	0.4%
588	355	0.4%
Other values (1601)	95669	95.7%

Value	Count	Frequency (%)
29	1	< 0.1%
30	1	< 0.1%
31	12	< 0.1%
41	2	< 0.1%
45	11	< 0.1%
50	3	< 0.1%
54	2	< 0.1%
61	4	< 0.1%
66	6	< 0.1%
67	61	0.1%

Value	Count	Frequency (%)
5812	1	< 0.1%
5095	5	< 0.1%
4983	13	< 0.1%
4962	3	< 0.1%
4904	2	< 0.1%
4817	4	< 0.1%
4757	1	< 0.1%
4678	2	< 0.1%
4502	12	< 0.1%
4475	1	< 0.1%

DELAY_DUE_CARRIER
Real number (ℝ)

High correlation Zeros

Distinct	422
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.48232

Minimum	0
Maximum	1473
Zeros	90096
Zeros (%)	90.1%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	20
Maximum	1473
Range	1473
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	31.972682
Coefficient of variation (CV)	7.1330655
Kurtosis	539.85777
Mean	4.48232
Median Absolute Deviation (MAD)	0
Skewness	19.571832
Sum	448232
Variance	1022.2524
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	90096	90.1%
2	312	0.3%
6	300	0.3%
3	297	0.3%
15	293	0.3%
5	285	0.3%
1	284	0.3%
16	276	0.3%
4	257	0.3%
9	256	0.3%
Other values (412)	7344	7.3%

Value	Count	Frequency (%)
0	90096	90.1%
1	284	0.3%
2	312	0.3%
3	297	0.3%
4	257	0.3%
5	285	0.3%
6	300	0.3%
7	249	0.2%
8	240	0.2%
9	256	0.3%

Value	Count	Frequency (%)
1473	1	< 0.1%
1458	1	< 0.1%
1376	1	< 0.1%
1256	1	< 0.1%
1155	1	< 0.1%
1147	1	< 0.1%
1121	1	< 0.1%
1115	1	< 0.1%
1088	1	< 0.1%
1066	1	< 0.1%

DELAY_DUE_WEATHER
Real number (ℝ)

High correlation Skewed Zeros

Distinct	224
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.69679

Minimum	0
Maximum	1285
Zeros	98965
Zeros (%)	99.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1285
Range	1285
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	12.81459
Coefficient of variation (CV)	18.390892
Kurtosis	2968.2942
Mean	0.69679
Median Absolute Deviation (MAD)	0
Skewness	44.380019
Sum	69679
Variance	164.21372
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	98965	99.0%
2	24	< 0.1%
16	22	< 0.1%
7	22	< 0.1%
6	21	< 0.1%
8	20	< 0.1%
32	19	< 0.1%
9	19	< 0.1%
3	19	< 0.1%
18	18	< 0.1%
Other values (214)	851	0.9%

Value	Count	Frequency (%)
0	98965	99.0%
1	17	< 0.1%
2	24	< 0.1%
3	19	< 0.1%
4	16	< 0.1%
5	17	< 0.1%
6	21	< 0.1%
7	22	< 0.1%
8	20	< 0.1%
9	19	< 0.1%

Value	Count	Frequency (%)
1285	1	< 0.1%
1059	1	< 0.1%
1000	1	< 0.1%
989	1	< 0.1%
825	1	< 0.1%
780	1	< 0.1%
733	1	< 0.1%
586	1	< 0.1%
565	1	< 0.1%
554	1	< 0.1%

DELAY_DUE_NAS
Real number (ℝ)

High correlation Skewed Zeros

Distinct	252
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.39749

Minimum	0
Maximum	1207
Zeros	91256
Zeros (%)	91.3%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	15
Maximum	1207
Range	1207
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	15.190141
Coefficient of variation (CV)	6.3358516
Kurtosis	1217.054
Mean	2.39749
Median Absolute Deviation (MAD)	0
Skewness	24.492451
Sum	239749
Variance	230.74038
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	91256	91.3%
1	449	0.4%
15	345	0.3%
3	319	0.3%
17	311	0.3%
16	305	0.3%
2	303	0.3%
5	287	0.3%
6	287	0.3%
18	279	0.3%
Other values (242)	5859	5.9%

Value	Count	Frequency (%)
0	91256	91.3%
1	449	0.4%
2	303	0.3%
3	319	0.3%
4	278	0.3%
5	287	0.3%
6	287	0.3%
7	260	0.3%
8	236	0.2%
9	203	0.2%

Value	Count	Frequency (%)
1207	1	< 0.1%
998	1	< 0.1%
978	1	< 0.1%
880	1	< 0.1%
865	1	< 0.1%
818	1	< 0.1%
696	1	< 0.1%
539	1	< 0.1%
442	1	< 0.1%
439	1	< 0.1%

DELAY_DUE_SECURITY
Real number (ℝ)

High correlation Skewed Zeros

Distinct	45
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.02508

Minimum	0
Maximum	249
Zeros	99898
Zeros (%)	99.9%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	249
Range	249
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.4182211
Coefficient of variation (CV)	56.547891
Kurtosis	18118.273
Mean	0.02508
Median Absolute Deviation (MAD)	0
Skewness	119.24109
Sum	2508
Variance	2.0113511
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=45)

Value	Count	Frequency (%)
0	99898	99.9%
1	7	< 0.1%
10	7	< 0.1%
17	6	< 0.1%
11	5	< 0.1%
15	5	< 0.1%
14	5	< 0.1%
18	4	< 0.1%
5	4	< 0.1%
27	4	< 0.1%
Other values (35)	55	0.1%

Value	Count	Frequency (%)
0	99898	99.9%
1	7	< 0.1%
2	2	< 0.1%
3	3	< 0.1%
4	2	< 0.1%
5	4	< 0.1%
6	3	< 0.1%
7	4	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
249	1	< 0.1%
233	1	< 0.1%
117	1	< 0.1%
116	1	< 0.1%
91	1	< 0.1%
81	1	< 0.1%
59	1	< 0.1%
58	1	< 0.1%
54	1	< 0.1%
50	1	< 0.1%

DELAY_DUE_LATE_AIRCRAFT
Real number (ℝ)

High correlation Zeros

Distinct	352
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.46947

Minimum	0
Maximum	1018
Zeros	91377
Zeros (%)	91.4%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	25
Maximum	1018
Range	1018
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	24.553319
Coefficient of variation (CV)	5.493564
Kurtosis	330.71888
Mean	4.46947
Median Absolute Deviation (MAD)	0
Skewness	13.548919
Sum	446947
Variance	602.8655
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	91377	91.4%
15	230	0.2%
16	200	0.2%
17	185	0.2%
18	184	0.2%
19	170	0.2%
12	166	0.2%
24	161	0.2%
20	156	0.2%
13	154	0.2%
Other values (342)	7017	7.0%

Value	Count	Frequency (%)
0	91377	91.4%
1	129	0.1%
2	121	0.1%
3	126	0.1%
4	117	0.1%
5	132	0.1%
6	109	0.1%
7	134	0.1%
8	116	0.1%
9	127	0.1%

Value	Count	Frequency (%)
1018	1	< 0.1%
1013	1	< 0.1%
1012	1	< 0.1%
960	1	< 0.1%
942	1	< 0.1%
889	1	< 0.1%
888	1	< 0.1%
840	1	< 0.1%
820	1	< 0.1%
802	1	< 0.1%

Interactions

Correlations

	AIRLINE	AIRLINE_CODE	AIRLINE_DOT	AIR_TIME	ARR_DELAY	ARR_TIME	CANCELLATION_CODE	CANCELLED	CRS_ARR_TIME	CRS_DEP_TIME	CRS_ELAPSED_TIME	DELAY_DUE_CARRIER	DELAY_DUE_LATE_AIRCRAFT	DELAY_DUE_NAS	DELAY_DUE_SECURITY	DELAY_DUE_WEATHER	DEP_DELAY	DEP_TIME	DISTANCE	DIVERTED	DOT_CODE	ELAPSED_TIME	FL_NUMBER	TAXI_IN	TAXI_OUT	WHEELS_OFF	WHEELS_ON
AIRLINE	1.000	1.000	1.000	0.169	0.026	0.048	0.249	0.043	0.050	0.048	0.173	0.013	0.016	0.026	0.007	0.012	0.026	0.048	0.176	0.011	1.000	0.169	0.415	0.020	0.091	0.049	0.048
AIRLINE_CODE	1.000	1.000	1.000	0.169	0.026	0.048	0.249	0.043	0.050	0.048	0.173	0.013	0.016	0.026	0.007	0.012	0.026	0.048	0.176	0.011	1.000	0.169	0.415	0.020	0.091	0.049	0.048
AIRLINE_DOT	1.000	1.000	1.000	0.169	0.026	0.048	0.249	0.043	0.050	0.048	0.173	0.013	0.016	0.026	0.007	0.012	0.026	0.048	0.176	0.011	1.000	0.169	0.415	0.020	0.091	0.049	0.048
AIR_TIME	0.169	0.169	0.169	1.000	0.034	0.044	0.000	1.000	0.052	-0.027	0.984	0.043	0.005	0.087	0.010	0.002	0.075	-0.028	0.986	1.000	-0.064	0.979	-0.334	0.125	0.071	-0.034	0.046
ARR_DELAY	0.026	0.026	0.026	0.034	1.000	0.110	0.000	1.000	0.112	0.130	-0.027	0.480	0.452	0.440	0.045	0.157	0.655	0.166	0.004	1.000	-0.033	0.099	-0.039	0.119	0.269	0.171	0.117
ARR_TIME	0.048	0.048	0.048	0.044	0.110	1.000	0.000	1.000	0.896	0.730	0.039	0.061	0.115	0.066	-0.002	0.025	0.132	0.753	0.049	0.036	-0.001	0.044	0.001	-0.028	0.028	0.768	0.976
CANCELLATION_CODE	0.249	0.249	0.249	0.000	0.000	0.000	1.000	1.000	0.070	0.078	0.061	1.000	1.000	1.000	1.000	1.000	0.145	0.097	0.066	1.000	0.154	0.000	0.133	0.000	0.000	0.000	0.000
CANCELLED	0.043	0.043	0.043	1.000	1.000	1.000	1.000	1.000	0.016	0.017	0.011	0.008	0.015	0.000	0.000	0.000	0.044	0.016	0.013	0.006	0.032	1.000	0.008	1.000	0.000	0.000	1.000
CRS_ARR_TIME	0.050	0.050	0.050	0.052	0.112	0.896	0.070	0.016	1.000	0.794	0.048	0.076	0.149	0.066	0.001	0.029	0.145	0.792	0.059	0.017	0.003	0.049	-0.006	-0.037	0.025	0.800	0.904
CRS_DEP_TIME	0.048	0.048	0.048	-0.027	0.130	0.730	0.078	0.017	0.794	1.000	-0.034	0.095	0.173	0.061	0.003	0.030	0.160	0.969	-0.023	0.012	0.010	-0.031	0.001	-0.066	0.004	0.953	0.751
CRS_ELAPSED_TIME	0.173	0.173	0.173	0.984	-0.027	0.039	0.061	0.011	0.048	-0.034	1.000	0.033	-0.003	0.056	0.008	0.000	0.071	-0.034	0.979	0.012	-0.022	0.974	-0.309	0.163	0.112	-0.039	0.040
DELAY_DUE_CARRIER	0.013	0.013	0.013	0.043	0.480	0.061	1.000	0.008	0.076	0.095	0.033	1.000	0.398	0.308	0.002	-0.018	0.463	0.127	0.039	0.000	-0.018	0.058	-0.033	0.013	0.062	0.126	0.066
DELAY_DUE_LATE_AIRCRAFT	0.016	0.016	0.016	0.005	0.452	0.115	1.000	0.015	0.149	0.173	-0.003	0.398	1.000	0.293	0.035	0.110	0.454	0.207	0.004	0.000	-0.020	0.015	-0.026	0.018	0.031	0.202	0.123
DELAY_DUE_NAS	0.026	0.026	0.026	0.087	0.440	0.066	1.000	0.000	0.066	0.061	0.056	0.308	0.293	1.000	0.042	0.136	0.288	0.083	0.055	0.000	0.049	0.163	-0.039	0.139	0.242	0.091	0.070
DELAY_DUE_SECURITY	0.007	0.007	0.007	0.010	0.045	-0.002	1.000	0.000	0.001	0.003	0.008	0.002	0.035	0.042	1.000	0.003	0.043	0.006	0.011	0.000	0.008	0.011	-0.014	-0.000	0.010	0.005	-0.001
DELAY_DUE_WEATHER	0.012	0.012	0.012	0.002	0.157	0.025	1.000	0.000	0.029	0.030	0.000	-0.018	0.110	0.136	0.003	1.000	0.152	0.043	-0.002	0.000	0.025	0.020	0.011	0.013	0.060	0.045	0.029
DEP_DELAY	0.026	0.026	0.026	0.075	0.655	0.132	0.145	0.044	0.145	0.160	0.071	0.463	0.454	0.288	0.043	0.152	1.000	0.203	0.084	0.018	-0.174	0.074	-0.084	-0.051	0.020	0.199	0.141
DEP_TIME	0.048	0.048	0.048	-0.028	0.166	0.753	0.097	0.016	0.792	0.969	-0.034	0.127	0.207	0.083	0.006	0.043	0.203	1.000	-0.024	0.013	0.004	-0.030	0.004	-0.064	0.008	0.984	0.774
DISTANCE	0.176	0.176	0.176	0.986	0.004	0.049	0.066	0.013	0.059	-0.023	0.979	0.039	0.004	0.055	0.011	-0.002	0.084	-0.024	1.000	0.009	-0.086	0.961	-0.351	0.110	0.055	-0.030	0.052
DIVERTED	0.011	0.011	0.011	1.000	1.000	0.036	1.000	0.006	0.017	0.012	0.012	0.000	0.000	0.000	0.000	0.000	0.018	0.013	0.009	1.000	0.013	1.000	0.008	0.053	0.014	0.013	0.039
DOT_CODE	1.000	1.000	1.000	-0.064	-0.033	-0.001	0.154	0.032	0.003	0.010	-0.022	-0.018	-0.020	0.049	0.008	0.025	-0.174	0.004	-0.086	0.013	1.000	-0.006	0.334	0.213	0.279	0.008	-0.003
ELAPSED_TIME	0.169	0.169	0.169	0.979	0.099	0.044	0.000	1.000	0.049	-0.031	0.974	0.058	0.015	0.163	0.011	0.020	0.074	-0.030	0.961	1.000	-0.006	1.000	-0.305	0.209	0.203	-0.032	0.046
FL_NUMBER	0.415	0.415	0.415	-0.334	-0.039	0.001	0.133	0.008	-0.006	0.001	-0.309	-0.033	-0.026	-0.039	-0.014	0.011	-0.084	0.004	-0.351	0.008	0.334	-0.305	1.000	-0.028	0.093	0.011	-0.002
TAXI_IN	0.020	0.020	0.020	0.125	0.119	-0.028	0.000	1.000	-0.037	-0.066	0.163	0.013	0.018	0.139	-0.000	0.013	-0.051	-0.064	0.110	0.053	0.213	0.209	-0.028	1.000	0.067	-0.063	-0.036
TAXI_OUT	0.091	0.091	0.091	0.071	0.269	0.028	0.000	0.000	0.025	0.004	0.112	0.062	0.031	0.242	0.010	0.060	0.020	0.008	0.055	0.014	0.279	0.203	0.093	0.067	1.000	0.028	0.031
WHEELS_OFF	0.049	0.049	0.049	-0.034	0.171	0.768	0.000	0.000	0.800	0.953	-0.039	0.126	0.202	0.091	0.005	0.045	0.199	0.984	-0.030	0.013	0.008	-0.032	0.011	-0.063	0.028	1.000	0.789
WHEELS_ON	0.048	0.048	0.048	0.046	0.117	0.976	0.000	1.000	0.904	0.751	0.040	0.066	0.123	0.070	-0.001	0.029	0.141	0.774	0.052	0.039	-0.003	0.046	-0.002	-0.036	0.031	0.789	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	FL_DATE	AIRLINE	AIRLINE_DOT	AIRLINE_CODE	DOT_CODE	FL_NUMBER	ORIGIN	ORIGIN_CITY	DEST	DEST_CITY	CRS_DEP_TIME	DEP_TIME	DEP_DELAY	TAXI_OUT	WHEELS_OFF	WHEELS_ON	TAXI_IN	CRS_ARR_TIME	ARR_TIME	ARR_DELAY	CANCELLED	CANCELLATION_CODE	CRS_ELAPSED_TIME	ELAPSED_TIME	AIR_TIME	DISTANCE	DELAY_DUE_CARRIER	DELAY_DUE_NAS	DELAY_DUE_LATE_AIRCRAFT
0	2019-03-01	Allegiant Air	Allegiant Air: G4	G4	20368	1668	PGD	Punta Gorda, FL	SPI	Springfield, IL	630	620.0	-10.0	9.0	629.0	731.0	7.0	810	738.0	-32.0	0.0	NaN	160.0	138.0	122.0	994.0	0.0	0.0	0.0
1	2021-02-16	American Airlines Inc.	American Airlines Inc.: AA	AA	19805	2437	DFW	Dallas/Fort Worth, TX	LAX	Los Angeles, CA	1329	NaN	NaN	NaN	NaN	NaN	NaN	1500	NaN	NaN	1.0	B	211.0	NaN	NaN	1235.0	0.0	0.0	0.0
2	2022-04-12	PSA Airlines Inc.	PSA Airlines Inc.: OH	OH	20397	5560	EWN	New Bern/Morehead/Beaufort, NC	CLT	Charlotte, NC	625	618.0	-7.0	16.0	634.0	725.0	11.0	744	736.0	-8.0	0.0	NaN	79.0	78.0	51.0	221.0	0.0	0.0	0.0
3	2021-10-13	Southwest Airlines Co.	Southwest Airlines Co.: WN	WN	19393	1944	ABQ	Albuquerque, NM	DEN	Denver, CO	1715	1740.0	25.0	15.0	1755.0	1844.0	7.0	1835	1851.0	16.0	0.0	NaN	80.0	71.0	49.0	349.0	10.0	0.0	6.0
4	2022-06-05	Southwest Airlines Co.	Southwest Airlines Co.: WN	WN	19393	3081	PIT	Pittsburgh, PA	STL	St. Louis, MO	535	535.0	0.0	12.0	547.0	609.0	6.0	620	615.0	-5.0	0.0	NaN	105.0	100.0	82.0	554.0	0.0	0.0	0.0
5	2019-10-06	Delta Air Lines Inc.	Delta Air Lines Inc.: DL	DL	19790	674	LAX	Los Angeles, CA	SEA	Seattle, WA	1140	1138.0	-2.0	14.0	1152.0	1405.0	11.0	1438	1416.0	-22.0	0.0	NaN	178.0	158.0	133.0	954.0	0.0	0.0	0.0
6	2020-03-17	Southwest Airlines Co.	Southwest Airlines Co.: WN	WN	19393	443	OAK	Oakland, CA	HOU	Houston, TX	2000	2019.0	19.0	13.0	2032.0	143.0	7.0	135	150.0	15.0	0.0	NaN	215.0	211.0	191.0	1642.0	15.0	0.0	0.0
7	2020-02-06	Southwest Airlines Co.	Southwest Airlines Co.: WN	WN	19393	1779	SFO	San Francisco, CA	SAN	San Diego, CA	1340	1338.0	-2.0	13.0	1351.0	1456.0	3.0	1520	1459.0	-21.0	0.0	NaN	100.0	81.0	65.0	447.0	0.0	0.0	0.0
8	2019-03-11	Delta Air Lines Inc.	Delta Air Lines Inc.: DL	DL	19790	2135	DTW	Detroit, MI	LAS	Las Vegas, NV	714	710.0	-4.0	30.0	740.0	854.0	10.0	847	904.0	17.0	0.0	NaN	273.0	294.0	254.0	1749.0	0.0	17.0	0.0
9	2022-07-24	Delta Air Lines Inc.	Delta Air Lines Inc.: DL	DL	19790	1612	DEN	Denver, CO	SLC	Salt Lake City, UT	2010	2038.0	28.0	16.0	2054.0	2159.0	5.0	2148	2204.0	16.0	0.0	NaN	98.0	86.0	65.0	391.0	16.0	0.0	0.0

	FL_DATE	AIRLINE	AIRLINE_DOT	AIRLINE_CODE	DOT_CODE	FL_NUMBER	ORIGIN	ORIGIN_CITY	DEST	DEST_CITY	CRS_DEP_TIME	DEP_TIME	DEP_DELAY	TAXI_OUT	WHEELS_OFF	WHEELS_ON	TAXI_IN	CRS_ARR_TIME	ARR_TIME	ARR_DELAY	CANCELLATION_CODE	CRS_ELAPSED_TIME	ELAPSED_TIME	AIR_TIME	DISTANCE	DELAY_DUE_CARRIER	DELAY_DUE_NAS	DELAY_DUE_LATE_AIRCRAFT
99990	2019-02-19	Southwest Airlines Co.	Southwest Airlines Co.: WN	WN	19393	377	DEN	Denver, CO	SEA	Seattle, WA	855	857.0	2.0	14.0	911.0	1043.0	4.0	1100	1047.0	-13.0	NaN	185.0	170.0	152.0	1024.0	0.0	0.0	0.0
99991	2019-02-21	Southwest Airlines Co.	Southwest Airlines Co.: WN	WN	19393	1752	BWI	Baltimore, MD	TPA	Tampa, FL	825	825.0	0.0	30.0	855.0	1102.0	6.0	1050	1108.0	18.0	NaN	145.0	163.0	127.0	842.0	0.0	18.0	0.0
99992	2022-06-29	Delta Air Lines Inc.	Delta Air Lines Inc.: DL	DL	19790	1643	ATL	Atlanta, GA	MSN	Madison, WI	950	946.0	-4.0	9.0	955.0	1036.0	8.0	1048	1044.0	-4.0	NaN	118.0	118.0	101.0	707.0	0.0	0.0	0.0
99993	2023-01-06	Spirit Air Lines	Spirit Air Lines: NK	NK	20416	1042	SJU	San Juan, PR	MCO	Orlando, FL	2130	2225.0	55.0	14.0	2239.0	17.0	39.0	2350	56.0	66.0	NaN	200.0	211.0	158.0	1189.0	0.0	11.0	55.0
99994	2023-08-05	United Air Lines Inc.	United Air Lines Inc.: UA	UA	19977	1478	LAS	Las Vegas, NV	IAH	Houston, TX	1023	1016.0	-7.0	30.0	1046.0	1517.0	3.0	1533	1520.0	-13.0	NaN	190.0	184.0	151.0	1222.0	0.0	0.0	0.0
99995	2019-02-26	Delta Air Lines Inc.	Delta Air Lines Inc.: DL	DL	19790	2229	CHS	Charleston, SC	ATL	Atlanta, GA	1244	1241.0	-3.0	13.0	1254.0	1344.0	10.0	1408	1354.0	-14.0	NaN	84.0	73.0	50.0	259.0	0.0	0.0	0.0
99996	2023-02-10	Southwest Airlines Co.	Southwest Airlines Co.: WN	WN	19393	2977	MDW	Chicago, IL	LAX	Los Angeles, CA	925	1134.0	129.0	19.0	1153.0	1322.0	11.0	1205	1333.0	88.0	NaN	280.0	239.0	209.0	1750.0	88.0	0.0	0.0
99997	2019-06-26	Endeavor Air Inc.	Endeavor Air Inc.: 9E	9E	20363	5003	ORF	Norfolk, VA	JFK	New York, NY	1712	1715.0	3.0	25.0	1740.0	1831.0	6.0	1845	1837.0	-8.0	NaN	93.0	82.0	51.0	290.0	0.0	0.0	0.0
99998	2023-06-22	Endeavor Air Inc.	Endeavor Air Inc.: 9E	9E	20363	5173	CVG	Cincinnati, OH	LGA	New York, NY	1433	1436.0	3.0	14.0	1450.0	1617.0	9.0	1640	1626.0	-14.0	NaN	127.0	110.0	87.0	585.0	0.0	0.0	0.0
99999	2022-01-07	Endeavor Air Inc.	Endeavor Air Inc.: 9E	9E	20363	5227	ATL	Atlanta, GA	SHV	Shreveport, LA	1345	1420.0	35.0	10.0	1430.0	1456.0	4.0	1438	1500.0	22.0	NaN	113.0	100.0	86.0	551.0	0.0	0.0	22.0

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length